{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["BExRepositorySheet","Table","Sheet1","Estado Situacion Financiera Det","Graph"],"not_rendered":{"charts":1,"images":21,"macros":1,"external_links":1,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"BExRepositorySheet","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[7]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Filter"]

{"sheet":"Table","index":1,"n_rows":67,"n_cols":12,"rows_kept":67,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,"Estado de Situacion Financiera Det A"]
[null,null,null,null,null,null,null,"Autor","ADVJYNOQUIO",null,"Actualidad de datos","25/01/2022 14:24:31"]
[]
[]
[null,null,null,null,null,null,"Information"]
[null,null,null,null,null,null,"Autor","ADVJYNOQUIO",null,"Últ.actual.pantalla","18/04/2022 10:13:39"]
[null,null,null,null,null,null,"Usuario actual","GRPMJRIOS",null,"Fe.clave","18/04/2022"]
[null,null,null,null,null,null,"Modificado por","ADVIVIEYRA",null,"Hora de modificación","07/05/2020 10:37:04"]
[null,null,null,null,null,null,"InfoSitio","ZVRL_MP02",null,"Actualidad de datos","25/01/2022 14:24:31"]
[null,null,null,null,null,null,"Nombre técnico query","ZFI_VRL_MP02_Q008A",null,"Actualidad datos (fecha)","25/01/2022"]
[null,null,null,null,null,null,"Descripción query","Estado de Situacion Financiera Det A",null,"Actualidad datos (fecha)","14:24:31"]
[]
[]
[null,null,"Filter",null,null,null,"Table"]
[null,null,"Área funcional","",null,null,"","Saldo Actual (ORIGINAL)","Saldo Anterior (ORIGINAL)","Saldo Actual (NUEVO)","Saldo Anterior (NUEVO)","Saldo acumulado"]
[null,null,"Centro de beneficio","",null,null,"Activo",0,0,0,0,0]
[null,null,"Centro de coste","",null,null,"  Activo Circulante",0,0,0,0,0]
[null,null,"Cuenta de mayor","",null,null,"    a. Efectivo y Equivalentes",0,0,6516071204.3299999,2227797176.3099999,5962711562.0299997]
[null,null,"Ejercicio/Período","",null,null,"    a1) Efectivo",0,0,690947579.41999996,315570440.27999997,2392582905.2600002]
[null,null,"Ejercicio","",null,null,"    a2) Bancos/Tesorería",0,0,4935363303.2299995,1075201313.4100001,2643967043.98]
[null,null,"Estruct.","",null,null,"    a3) Bancos/Dependencias y Otros",0,0]
[null,null,"InfoSitio","",null,null,"    a4) Inversiones Temporales (Hasta 3 meses)",0,0,11166349.01,424249102.75,424249102.75]
[null,null,"Período contable","",null,null,"    a5) Fondos con Afectación Específica",0,0,878564966.66999996,412747313.87,501883504.04000002]
[null,null,"Ratios","",null,null,"    a6) Depósitos de Fondos de Terceros en Garantía y/o",0,0]
[null,null,null,null,null,null,"    a7) Otros Efectivos y Equivalentes",0,0,29006,29006,29006]
[null,null,null,null,null,null,"    b. Derechos a Recibir Efectivo o Equivalentes",0,0,3817278827.73,1450496828.01,918824573.46000004]
[null,null,null,null,null,null,"    b1) Inversiones Financieras de Corto Plazo",0,0,-0.05,-0.05,-0.05]
[null,null,null,null,null,null,"    b2) Cuentas por Cobrar a Corto Plazo",0,0,39490.47,39490.47,779707622.24000001]
[null,null,null,null,null,null,"    b3) Deudores Diversos por Cobrar a Corto Plazo",0,0,2935092239.2399998,682112288,-715364823.63]
[null,null,null,null,null,null,"    b4) Ingresos por Recuperar a Corto Plazo",0,0,1686.79,35016.93,-60138.52]
[null,null,null,null,null,null,"    b5) Deudores por Anticipos de la Tesorería a Corto Plazo",0,0,39012903.549999997,38201343.57,45007919.289999999]
[null,null,null,null,null,null,"    b6) Préstamos Otorgados a Corto Plazo",0,0,47062228.299999997,47996401.299999997,47996401.299999997]
[null,null,null,null,null,null,"    b7) Otros Derechos a Recibir Efectivo o Equivalentes a C",0,0,796070279.42999995,682112287.78999996,761537592.83000004]
[null,null,null,null,null,null,"    c. Derechos a Recibir Bienes o Servicios",0,0,461855557.01999998,318860347.33999997,316062871.94]
[null,null,null,null,null,null,"    c1) Anticipo a Proveedores por Adquisición de Bienes y",0,0]
[null,null,null,null,null,null,"    c2) Anticipo a Proveedores por Adquisición de Bienes Inm",0,0]
[null,null,null,null,null,null,"    c3) Anticipo a Proveedores por Adquisición de Bienes Int",0,0]
[null,null,null,null,null,null,"    c4) Anticipo a Contratistas por Obras Públicas a Corto P",0,0,461855557.01999998,318860347.33999997,316062871.94]
[null,null,null,null,null,null,"    c5) Otros Derechos a Recibir Bienes o Servicios a Corto",0,0]
[null,null,null,null,null,null,"    d. Inventarios",0,0]
[null,null,null,null,null,null,"    d1) Inventario de Mercancías para Venta",0,0]
[null,null,null,null,null,null,"    d2) Inventario de Mercancías Terminadas",0,0]
[null,null,null,null,null,null,"    d3) Inventario de Mercancías en Proceso de Elaboración",0,0]
[null,null,null,null,null,null,"    d4) Inventario de Materias Primas, Materiales y Suminist",0,0]
[null,null,null,null,null,null,"    d5) Bienes en Tránsito",0,0]
[null,null,null,null,null,null,"    e. Almacenes",0,0,614872.34,582533.62,582533.62]
[null,null,null,null,null,null,"    f. Estimación por Pérdida o Deterioro de Activos Circ.",0,0]
[null,null,null,null,null,null,"    f1) Estimaciones para Cuentas Incobrables por Derechos a",0,0]
[null,null,null,null,null,null,"    f2) Estimación por Deterioro de Inventarios",0,0]
[null,null,null,null,null,null,"    g. Otros Activos Circulantes",0,0,18899998.010000002,0,0]
[null,null,null,null,null,null,"    g1) Valores en Garantía",0,0,18899998.010000002,0,0]
[null,null,null,null,null,null,"    g2) Bienes en Garantía (excluye depósitos de fondos)",0,0]
[null,null,null,null,null,null,"    g3) Bienes Derivados de Embargos, Decomisos, Aseguramien",0,0]
[null,null,null,null,null,null,"    g4) Adquisición con Fondos de Terceros",0,0]
[null,null,null,null,null,null,"  IA. Total de Activos Circulantes",0,0,10814720459.43,3997736885.2800002,7198181541.0500002]
[null,null,null,null,null,null,"  Activo No Circulante",0,0,0,0,0]
[null,null,null,null,null,null,"    a. Inversiones Financieras a Largo Plazo",0,0,23589794427.099998,24674913677.700001,24660997974]
[null,null,null,null,null,null,"    b. Derechos a Recibir Efectivo o Equivalentes a LP",0,0,180010314.5,180010314.5,180010314.5]
[null,null,null,null,null,null,"    c. Bienes Inmuebles, Infra. y Construcc. en Proceso",0,0,16271264427.290001,18750221859.080002,18750221859.080002]
[null,null,null,null,null,null,"    d. Bienes Muebles",0,0,2999763599.3400002,3136449692.4299998,3136534859.6300001]
[null,null,null,null,null,null,"    e. Activos Intangibles",0,0,125823150.47,137079404.19,137079404.19]
[null,null,null,null,null,null,"    f. Depreciación, Deterioro y Amort. Acum. de Bien",0,0,-1103599441.3499999,-1117944837.25,-1131190122.48]
[null,null,null,null,null,null,"    g. Activos Diferidos",0,0,32457644.670000002,32457644.670000002,32457644.670000002]
[null,null,null,null,null,null,"    h. Estimación por Pérdida o Det. de Activos no Circulant",0,0]
[null,null,null,null,null,null,"    i. Otros Activos no Circulantes",0,0]
[null,null,null,null,null,null,"  IB. Total de Activos No Circulantes",0,0,42095514122.019997,45793187755.32,45766111933.589996]
[null,null,null,null,null,null,"I. Total del Activo",0,0,52910234581.449997,49790924640.599998,52964293474.639999]

{"sheet":"Sheet1","index":2,"n_rows":80,"n_cols":12,"rows_kept":80,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,"","Saldo Actual (ORIGINAL)","Saldo Anterior (ORIGINAL)","Saldo Actual (NUEVO)","Saldo Anterior (NUEVO)","Saldo acumulado"]
[null,null,null,null,null,null,"Pasivo",null,null,null,null,0]
[null,null,null,null,null,null,"  Pasivo Circulante",null,null,null,null,0]
[null,null,null,null,null,null,"    a. Cuentas por Pagar a Corto Plazo",0,0,6057384845.9899998,4822360379.1400003,-9194590873.2600002]
[null,null,null,null,null,null,"    a1) Servicios Personales por Pagar a Corto Plazo",0,0,885523896.02999997,575473440.38999999,-3683689622.2600002]
[null,null,null,null,null,null,"    a2) Proveedores por Pagar a Corto Plazo",0,0,407860016.19999999,1031669913.87,-1122227750.6199999]
[null,null,null,null,null,null,"    a3) Contratistas por Obras Públicas por Pagar a Corto Pl",0,0,119350985.47,58032388.350000001,-51170180.109999999]
[null,null,null,null,null,null,"    a4) Participaciones y Aportaciones por Pagar a Corto Pla",0,0,70099073.760000005,69455911.519999996,-435146536.51999998]
[null,null,null,null,null,null,"    a5) Transferencias Otorgadas por Pagar a Corto Plazo",0,0,1808091546.99,945130300.88,-1341326895.25]
[null,null,null,null,null,null,"    a6) Intereses, Comisiones y Otros Gastos de la Deuda Púb",0,0,15409518.93,4620052.1100000003,-24586365.579999998]
[null,null,null,null,null,null,"    a7) Retenciones y Contribuciones por Pagar a Corto Plazo",0,0,2075124124.8099999,2126099628.5699999,-2436874001.0700002]
[null,null,null,null,null,null,"    a8) Devoluciones de la Ley de Ingresos por Pagar a Corto",0,0,-604784.49,334238.95,-869356.13]
[null,null,null,null,null,null,"    a9) Otras Cuentas por Pagar a Corto Plazo",0,0,676530468.28999996,11544504.5,-98700165.719999999]
[null,null,null,null,null,null,"    b. Documentos por Pagar a Corto Plazo",0,0,1164000000,2732000000,-1088888890]
[null,null,null,null,null,null,"    b1) Documentos Comerciales por Pagar a Corto Plazo",0,0,1164000000,2732000000,-1088888890]
[null,null,null,null,null,null,"    b2) Documentos con Contratistas por Obras Públicas por P",0,0]
[null,null,null,null,null,null,"    b3) Otros Documentos por Pagar a Corto Plazo",0,0]
[null,null,null,null,null,null,"    c. Porción a Corto Plazo de la Deuda Pública",0,0,529810506.92000002,614280699.38999999,-515175672.48000002]
[null,null,null,null,null,null,"    c1) Porción a Corto Plazo de la Deuda Pública",0,0,529810506.92000002,614280699.38999999,-515175672.48000002]
[null,null,null,null,null,null,"    c2) Porción a Corto Plazo de Arrendamiento Financiero",0,0]
[null,null,null,null,null,null,"    d. Títulos y Valores a Corto Plazo",0,0]
[null,null,null,null,null,null,"    e. Pasivos Diferidos a Corto Plazo",0,0]
[null,null,null,null,null,null,"    e1) Ingresos Cobrados por Adelantado a Corto Plazo",0,0]
[null,null,null,null,null,null,"    e2) Intereses Cobrados por Adelantado a Corto Plazo",0,0]
[null,null,null,null,null,null,"    e3) Otros Pasivos Diferidos a Corto Plazo",0,0]
[null,null,null,null,null,null,"    f. Fondos y Bienes de Terceros en Garantía",0,0,231751083.58000001,225197033.99000001,-219825032.11000001]
[null,null,null,null,null,null,"    f1) Fondos en Garantía a Corto Plazo",0,0,11964477.58,13646383.58,-13650343.58]
[null,null,null,null,null,null,"    f2) Fondos en Administración a Corto Plazo",0,0,219786606,211550650.41,-206174688.53]
[null,null,null,null,null,null,"    f3) Fondos Contingentes a Corto Plazo",0,0]
[null,null,null,null,null,null,"    f4) Fondos de Fideicomisos, Mandatos y Contratos Análogo",0,0]
[null,null,null,null,null,null,"    f5) Otros Fondos de Terceros en Garantía y/o Administrac",0,0]
[null,null,null,null,null,null,"    f6) Valores y Bienes en Garantía a Corto Plazo",0,0]
[null,null,null,null,null,null,"    g. Provisiones a Corto Plazo",0,0]
[null,null,null,null,null,null,"    g1) Provisión para Demandas y Juicios a Corto Plazo",0,0]
[null,null,null,null,null,null,"    g2) Provisión para Contingencias a Corto Plazo",0,0]
[null,null,null,null,null,null,"    g3) Otras Provisiones a Corto Plazo",0,0]
[null,null,null,null,null,null,"    h. Otros Pasivos a Corto Plazo",0,0,-626881224.97000003,595184227.94000006,672463756.80999994]
[null,null,null,null,null,null,"    h1) Ingresos por Clasificar",0,0,2611013.15,2800125.72,-2800125.72]
[null,null,null,null,null,null,"    h2) Recaudación por Participar",0,0,-782900195.51999998,453192912.70999998,821911324.42999995]
[null,null,null,null,null,null,"    h3) Otros Pasivos Circulantes",0,0,153407957.40000001,139191189.50999999,-146647441.90000001]
[null,null,null,null,null,null,"  IIA. Total de Pasivos Circulantes",0,0,7356065211.5200005,8989022340.4599991,-10346016711.040001]
[null,null,null,null,null,null,"  Pasivo No Circulante",null,null,null,null,0]
[null,null,null,null,null,null,"    a. Cuentas por Pagar a Largo Plazo",0,0,0,0,0]
[null,null,null,null,null,null,"    b. Documentos por Pagar a Largo Plazo",0,0]
[null,null,null,null,null,null,"    c. Deuda Pública a Largo Plazo",0,0,19874251150.099998,19259970436.740002,-19259970436.740002]
[null,null,null,null,null,null,"    d. Pasivos Diferidos a Largo Plazo",0,0]
[null,null,null,null,null,null,"    e. Fondos y Bienes de Terceros en Garantía",0,0]
[null,null,null,null,null,null,"    f. Provisiones a Largo Plazo",0,0]
[null,null,null,null,null,null,"  IIB. Total de Pasivos No Circulantes",0,0,19874251150.099998,19259970436.740002,-19259970436.740002]
[null,null,null,null,null,null,"II. Total del Pasivo",0,0,27230316361.619999,28248992777.200001,-29605987147.779999]
[null,null,null,null,null,null,"Hacienda Pública/Patrimonio",null,null,null,null,0]
[null,null,null,null,null,null,"  IIIA. Hacienda Pública/Patrimonio Contribuido",0,0,34179863229.939999,34703702039.620003,-34703702039.620003]
[null,null,null,null,null,null,"    Aportaciones",0,0,34174288674.59,34694530521.660004,-34694530521.660004]
[null,null,null,null,null,null,"    Donaciones de Capital",0,0]
[null,null,null,null,null,null,"    Actualización de la Hacienda Pública/Pa",0,0,5574555.3499999996,9171517.9600000009,-9171517.9600000009]
[null,null,null,null,null,null,"  IIIB. Hacienda Pública/Patrimonio Generado",0,0,8596826474.9099998,7765410595.79,-10451932555.74]
[null,null,null,null,null,null,"    Resultados del Ejercicio (Ahorro/ Desahorro)",0,0,1889089343.8099999,1057673464.6900001,-2686521959.9499998]
[null,null,null,null,null,null,"    Resultados de Ejercicios Anteriores",0,0,6707737131.1000004,6707737131.1000004,-7765410595.79]
[null,null,null,null,null,null,"    Revalúos",0,0]
[null,null,null,null,null,null,"    Reservas",0,0]
[null,null,null,null,null,null,"    Rectificaciones de Resultados de Ejercicios Anteriores",0,0,-17096771485.02,-20927180772.009998,21797328268.5]
[null,null,null,null,null,null,"  IIIC. Exceso o Insuficiencia en la Actualización de la Hac",0,0]
[null,null,null,null,null,null,"    Resultado por Tenencia de Activos no Monetarios",0,0]
[null,null,null,null,null,null,"    Resultado por Tenencia de Activos no Mo",0,0]
[null,null,null,null,null,null,"III. Total Hacienda Pública/Patrimonio",0,0,42776689704.849998,42469112635.410004,-45155634595.360001]
[null,null,null,null,null,null,"IV. Total del Pasivo y Hacienda Pública/Patrimonio",0,0,70007006066.470001,70718105412.610001,-74761621743.139999]

{"sheet":"Estado Situacion Financiera Det","index":3,"n_rows":85,"n_cols":25,"rows_kept":85,"cut":false,"hidden":false,"merged":[[2,1,2,6],[3,1,3,6],[4,1,4,6],[5,1,5,6]]}
["2018","1..12",null,"Gob del Edo de Michoacán","16/10/2018","Selección vacía","12","Enero",null,"1","2018-12-31",31,null,null,null,null,null,null,"12","2017","1..12","4to Trimestre 2018","4to Trimestre 2017","12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1..12"]
[null,"GOBIERNO DEL ESTADO DE MICHOACÁN DE OCAMPO",null,null,null,null,null,null,null,null,"H",null,"001.2021"]
[null,"Estado de Situación Financiera Detallado - LDF",null,null,null,null,null,null,null,null,"L",null,"016.2021",null,null,null,null,null,null,"Actual","12",12,"Diciembre",1,"Enero"]
[null,"Al 31 de Diciembre del 2021 y al 31 de Diciembre del 2020",null,null,null,null,null,null,null,null,null,null,"25/01/2022",null,null,null,null,null,null,"Anterior","12",12,"Diciembre",2,"Febrero"]
[null,"(Pesos)",null,null,null,null,null,null,null,null,"L",null,{"$f":"MID(M4,2,2)","v":"16"},{"$f":"VALUE(M6)","v":16},{"$f":"VLOOKUP(N6,$R$6:$S$21,2,0)","v":"Diciembre"},null,null,{"$f":"VALUE(1)","v":1},"Enero",{"$f":"MID(T4,2,2)","v":"ct"},null,null,null,5,"Mayo"]
[null,"Concepto (c)","Diciembre 2021","Diciembre. 2020","Concepto (c)","Diciembre 2021","Diciembre. 2020",null,null,null,"DIA CONSULTA",null,{"$f":"MID(M5,1,2)","v":"25"},25,null,null,null,{"$f":"VALUE(2)","v":2},"Febrero",{"$f":"MID(T5,1,2)","v":"An"},null,null,null,6,"Junio"]
[null,"ACTIVO",null,null,"PASIVO",null,null,null,null,null,"MES CONSULTA",null,{"$f":"MID(M5,4,2)","v":"01"},1,{"$f":"VLOOKUP(N8,R6:S17,2,0)","v":"Enero"},null,null,{"$f":"VALUE(3)","v":3},"Marzo",{"$f":"MID(T5,4,2)","v":"er"},null,null,null,7,"Julio"]
[null,"Activo Circulante",null,null,"Pasivo Circulante",null,null,null,null,null,"AÑO CONSULTA",null,{"$f":"MID(M3,5,4)","v":"2021"},2021,null,null,null,{"$f":"VALUE(4)","v":4},"Abril",{"$f":"MID(T5,7,4)","v":"or"},null,null,null,8,"Agosto"]
[null,"  a. Efectivo y Equivalentes  (a=a1+a2+a3+a4+a5+a6+a7)",{"$f":"SUM(C11:C17)","v":2227797176.3099999},{"$f":"SUM(D11:D17)","v":5459137507},"a. Cuentas por Pagar a Corto Plazo (a=a1+a2+a3+a4+a5+a6+a7+a8+a9)",{"$f":"SUM(F11:F19)","v":4846726152.2699995},{"$f":"SUM(G11:G19)","v":5454330933},null,null,null,null,null,{"$f":"MID(M4,5,4)","v":"2021"},2021,null,null,null,{"$f":"VALUE(5)","v":5},"Mayo",null,null,null,null,9,"Septiembre"]
[null,"    a1) Efectivo",315570440.27999997,4637341,"    a1) Servicios Personales por Pagar a Corto Plazo",575473440.38999999,459734416,null,null,null,null,null,null,null,null,null,null,{"$f":"VALUE(6)","v":6},"Junio",null,null,null,null,10,"Octubre"]
[null,"    a2) Bancos/Tesorería",1075201313.4100001,4067212273,"    a2) Proveedores por Pagar a Corto Plazo",1056035687,459784135,null,null,null,"AÑO LOW ",null,{"$f":"MID(M4,5,4)","v":"2021"},null,null,null,null,{"$f":"VALUE(7)","v":7},"Julio",{"$f":"MID(T4,5,4)","v":"al"},null,null,null,11,"Noviembre"]
[null,"    a3) Bancos/Dependencias y Otros",0,0,"    a3) Contratistas por Obras Públicas por Pagar a Corto Plazo",58032388.350000001,212508864,null,null,null,"AÑO HIGH",null,{"$f":"MID(M3,5,4)","v":"2021"},null,null,null,null,{"$f":"VALUE(8)","v":8},"Agosto",{"$f":"MID(T3,5,4)","v":""},null,null,null,12,"Diciembre"]
[null,"    a4) Inversiones Temporales (Hasta 3 meses)",424249102.75,11166349,"    a4) Participaciones y Aportaciones por Pagar a Corto Plazo",69455911.519999996,70287166,null,null,null,null,null,null,null,null,null,null,{"$f":"VALUE(9)","v":9},"Septiembre"]
[null,"    a5) Fondos con Afectación Específica",412747313.87,1376092538,"    a5) Transferencias Otorgadas por Pagar a Corto Plazo",945130300.88,1906522219,null,null,null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,null,null,null,{"$f":"VALUE(10)","v":10},"Octubre"]
[null,"    a6) Depósitos de Fondos de Terceros en Garantía y/o  Administración",0,0,"    a6) Intereses, Comisiones y Otros Gastos de la Deuda Pública por Pagar a Corto Plazo",4620052.1100000003,15409420,null,null,null,{"$f":"EOMONTH(K15,0)","v":{"$error":"#REF!"}},null,{"$f":"EOMONTH(M15,0)","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"VALUE(11)","v":11},"Noviembre"]
[null,"    a7) Otros Efectivos y Equivalentes",29006,29006,"    a7) Retenciones y Contribuciones por Pagar a Corto Plazo",2126099628.5699999,2330084713,null,null,null,null,null,null,null,null,null,null,{"$f":"VALUE(12)","v":12},"Diciembre"]
[null,"  b. Derechos a Recibir Efectivo o Equivalentes (b=b1+b2+b3+b4+b5+b6+b7)",{"$f":"SUM(C19:C25)","v":1450496828.0099998},{"$f":"SUM(D19:D25)","v":3131463044},"    a8) Devoluciones de la Ley de Ingresos por Pagar a Corto Plazo",334238.95,0,null,null,null,{"$f":"CONCATENATE(\"01/\",IF(OR(M6=\"13\",M6=\"14\",M6=\"15\",M6=\"16\"),\"12\",M6),\"/\",M12)","v":"01/12/2021"},null,null,null,null,null,null,13,"Diciembre"]
[null,"    b1) Inversiones Financieras de Corto Plazo",-0.05,0,"    a9) Otras Cuentas por Pagar a Corto Plazo",11544504.5,0,null,null,null,{"$f":"EOMONTH(K18,0)","v":"2021-12-31"},null,null,null,null,null,null,14,"Diciembre"]
[null,"    b2) Cuentas por Cobrar a Corto Plazo",39490.47,39490,"b. Documentos por Pagar a Corto Plazo (b=b1+b2+b3)",{"$f":"SUM(F21:F23)","v":2732000000},{"$f":"SUM(G21:G23)","v":1164000000},null,null,null,null,null,null,null,null,null,null,15,"Diciembre"]
[null,"    b3) Deudores Diversos por Cobrar a Corto Plazo",682112288,2246326759,"    b1) Documentos Comerciales por Pagar a Corto Plazo",2732000000,1164000000,null,null,null,{"$f":"TEXT(K16,\"dd\")","v":{"$error":"#REF!"}},null,{"$f":"TEXT(M16,\"dd\")","v":{"$error":"#REF!"}},null,null,null,null,16,"Diciembre"]
[null,"    b4) Ingresos por Recuperar a Corto Plazo",35016.93,1687,"    b2) Documentos con Contratistas por Obras Públicas por Pagar a Corto Plazo",0,0,null,null,null,{"$f":"TEXT(K19,\"dd\")","v":"31"}]
[null,"    b5) Deudores por Anticipos de la Tesorería a Corto Plazo",38201343.57,38312904,"    b3) Otros Documentos por Pagar a Corto Plazo",0,0]
[null,"    b6) Préstamos Otorgados a Corto Plazo",47996401.299999997,47149644,"c. Porción a Corto Plazo de la Deuda Pública a Largo Plazo (c=c1+c2)",{"$f":"SUM(F25:F26)","v":614280699.38999999},{"$f":"SUM(G25:G26)","v":548877782},null,null,null,{"$error":"#REF!"}]
[null,"    b7) Otros Derechos a Recibir Efectivo o Equivalentes a Corto Plazo",682112287.78999996,799632560,"    c1) Porción a Corto Plazo de la Deuda Pública",614280699.38999999,548877782,null,null,null,{"$error":"#REF!"}]
[null,"  c. Derechos a Recibir Bienes o Servicios (c=c1+c2+c3+c4+c5)",{"$f":"SUM(C27:C31)","v":318860347.33999997},{"$f":"SUM(D27:D31)","v":461647153},"    c2) Porción a Corto Plazo de Arrendamiento Financiero",0,0]
[null,"     c1) Anticipo a Proveedores por Adquisición de Bienes y Prestación de Servicios a Corto Plazo",0,0,"d. Títulos y Valores a Corto Plazo",0,0]
[null,"    c2) Anticipo a Proveedores por Adquisición de Bienes Inmuebles y Muebles a Corto Plazo",0,0,"e. Pasivos Diferidos a Corto Plazo (e=e1+e2+e3)",0,0]
[null,"    c3) Anticipo a Proveedores por Adquisición de Bienes Intangibles a Corto Plazo",0,0,"    e1) Ingresos Cobrados por Adelantado a Corto Plazo",0,0]
[null,"    c4) Anticipo a Contratistas por Obras Públicas a Corto Plazo",318860347.33999997,461647153,"    e2) Intereses Cobrados por Adelantado a Corto Plazo",0,0]
[null,"    c5) Otros Derechos a Recibir Bienes o Servicios a Corto Plazo",0,0,"    e3) Otros Pasivos Diferidos a Corto Plazo",0,0]
[null,"d. Inventarios (d=d1+d2+d3+d4+d5)",0,0,"f. Fondos y Bienes de Terceros en Garantía y/o Administración a Corto Plazo (f=f1+f2+f3+f4+f5+f6)",{"$f":"SUM(F33:F38)","v":225197033.99000001},{"$f":"SUM(G33:G38)","v":230452662}]
[null,"    d1) Inventario de Mercancías para Venta",0,0,"    f1) Fondos en Garantía a Corto Plazo",13646383.58,11960977]
[null,"    d2) Inventario de Mercancías Terminadas",0,0,"    f2) Fondos en Administración a Corto Plazo",211550650.41,218491685]
[null,"    d3) Inventario de Mercancías en Proceso de Elaboración",0,0,"    f3) Fondos Contingentes a Corto Plazo",0,0]
[null,"    d4) Inventario de Materias Primas, Materiales y Suministros para Producción",0,0,"    f4) Fondos de Fideicomisos, Mandatos y Contratos Análogos a Corto Plazo",0,0]
[null,"    d5) Bienes en Tránsito",0,0,"    f5) Otros Fondos de Terceros en Garantía y/o Administración a Corto Plazo",0,0]
[null,"e. Almacenes",582533.62,614872,"    f6) Valores y Bienes en Garantía a Corto Plazo",0,0]
[null,"f. Estimación por Pérdida o Deterioro de Activos Circulantes (f=f1+f2)",0,0,"g. Provisiones a Corto Plazo (g=g1+g2+g3)",0,0]
[null,"    f1) Estimaciones para Cuentas Incobrables por Derechos a Recibir Efectivo o Equivalentes",0,0,"    g1) Provisión para Demandas y Juicios a Corto Plazo",0,0]
[null,"    f2) Estimación por Deterioro de Inventarios",0,0,"    g2) Provisión para Contingencias a Corto Plazo",0,0]
[null,"g. Otros Activos Circulantes (g=g1+g2+g3+g4)",0,18899998,"    g3) Otras Provisiones a Corto Plazo",0,0]
[null,"    g1) Valores en Garantía",0,18899998,"h. Otros Pasivos a Corto Plazo (h=h1+h2+h3)",{"$f":"SUM(F44:F46)","v":595184227.94000006},{"$f":"SUM(G44:G46)","v":903437233}]
[null,"    g2) Bienes en Garantía (excluye depósitos de fondos)",0,0,"    h1) Ingresos por Clasificar",2800125.72,2611013]
[null,"    g3) Bienes Derivados de Embargos, Decomisos, Aseguramientos y Dación en Pago",0,0,"    h2) Recaudación por Participar",453192912.70999998,751182269]
[null,"    g4) Adquisición con Fondos de Terceros",0,0,"    h3) Otros Pasivos Circulantes",139191189.50999999,149643951]
[]
[null,"IA. Total de Activos Circulantes (IA = a + b + c + d + e + f + g)",{"$f":"+C10+C18+C26+C32+C38+C39+C42","v":3997736885.2799997},{"$f":"+D10+D18+D26+D32+D38+D39+D42","v":9071762574},"IIA. Total de Pasivos Circulantes (IIA = a + b + c + d + e + f + g + h)",{"$f":"+F10+F20+F24+F27+F28+F32+F39+F43","v":9013388113.5900002},{"$f":"+G10+G20+G24+G27+G28+G32+G39+G43","v":8301098610}]
[]
[null,"Activo No Circulante",null,null,"Pasivo No Circulante"]
[null,"a. Inversiones Financieras a Largo Plazo",24674913677.700001,24508848618,"a. Cuentas por Pagar a Largo Plazo",0,0]
[null,"b. Derechos a Recibir Efectivo o Equivalentes a Largo Plazo ",180010314.5,180010314,"b. Documentos por Pagar a Largo Plazo",0,0]
[null,"c. Bienes Inmuebles, Infraestructura y Construcciones en Proceso ",18750221859.080002,16152510711,"c. Deuda Pública a Largo Plazo",19259970436.740002,19874251150]
[null,"d. Bienes Muebles ",3136449692.4299998,3002953599,"d. Pasivos Diferidos a Largo Plazo",0,0]
[null,"e. Activos Intangibles ",137079404.19,125823150,"e. Fondos y Bienes de Terceros en Garantía y/o en Administración a Largo Plazo",0,0]
[null,"f. Depreciación, Deterioro y Amortización Acumulada de Bienes ",-1117944837.25,-1103599441,"f. Provisiones a Largo Plazo",0,0]
[null,"g. Activos Diferidos",32457644.670000002,32457645]
[null,"h. Estimación por Pérdida o Deterioro de Activos no Circulantes",0,0,"IIB. Total de Pasivos No Circulantes (IIB = a + b + c + d + e + f)",{"$f":"SUM(F51:F57)","v":19259970436.740002},{"$f":"SUM(G51:G57)","v":19874251150}]
[null,"i. Otros Activos no Circulantes",0,0]
[null,null,null,null,"II. Total del Pasivo (II = IIA + IIB)",{"$f":"+F48+F58","v":28273358550.330002},{"$f":"+G48+G58","v":28175349760}]
[null,"IB. Total de Activos No Circulantes (IB = a + b + c + d + e + f + g + h + i)",{"$f":"SUM(C51:C60)","v":45793187755.32},{"$f":"SUM(D51:D60)","v":42899004596}]
[null,null,null,null,"HACIENDA PÚBLICA/PATRIMONIO"]
[null,"I. Total del Activo (I = IA + IB)",{"$f":"+C48+C61","v":49790924640.599998},{"$f":"+D48+D61","v":51970767170}]
[null,null,null,null,"IIIA. Hacienda Pública/Patrimonio Contribuido (IIIA = a + b + c)",{"$f":"SUM(F65:F67)","v":34703702039.620003},{"$f":"SUM(G65:G67)","v":34179863229}]
[null,null,null,null,"a. Aportaciones",34694530521.660004,34174288674]
[null,null,null,null,"b. Donaciones de Capital",0,0]
[null,null,null,null,"c. Actualización de la Hacienda Pública/Patrimonio",9171517.9600000009,5574555]
[]
[null,null,null,null,"IIIB. Hacienda Pública/Patrimonio Generado (IIIB = a + b + c + d + e)",{"$f":"SUM(F70:F74)","v":-13186135948.909998},{"$f":"SUM(G70:G74)","v":-10384445819}]
[null,null,null,null,"a. Resultados del Ejercicio (Ahorro/ Desahorro)",1033307692,1329416831]
[null,null,null,null,"b. Resultados de Ejercicios Anteriores",6707737131.1000004,5378320300]
[null,null,null,null,"c. Revalúos",0,0]
[null,null,null,null,"d. Reservas",0,0]
[null,null,null,null,"e. Rectificaciones de Resultados de Ejercicios Anteriores",-20927180772.009998,-17092182950]
[]
[null,null,null,null,"IIIC. Exceso o Insuficiencia en la Actualización de la Hacienda Pública/Patrimonio (IIIC=a+b)",0,0]
[null,null,null,null,"a. Resultado por Posición Monetaria",0,0]
[null,null,null,null,"b. Resultado por Tenencia de Activos no Monetarios",0,0]
[]
[null,null,null,null,"III. Total Hacienda Pública/Patrimonio (III = IIIA + IIIB + IIIC)",{"$f":"+F64+F69","v":21517566090.710007},{"$f":"+G64+G69","v":23795417410}]
[]
[null,null,null,null,"IV. Total del Pasivo y Hacienda Pública/Patrimonio (IV = II + III)",{"$f":"+F60+F80","v":49790924641.040009},{"$f":"+G60+G80","v":51970767170}]
[]
[]
[null,null,null,null,null,{"$f":"+C63-F82","v":-0.44001007080078125},{"$f":"+G82-D63","v":0}]

{"sheet":"Graph","index":4,"n_rows":48,"n_cols":12,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,"FEP8Qry3"]
[null,null,null,null,null,null,null,"Autor","ADVJYNOQUIO",null,"Actualidad datos (fecha)","14:24:31"]
[]
[]
[null,null,null,null,null,null,"Information"]
[null,null,null,null,null,null,"Autor","ADVJYNOQUIO",null,"Últ.actual.pantalla","18/04/2022 10:13:39"]
[null,null,null,null,null,null,"Usuario actual","GRPMJRIOS",null,"Fe.clave","18/04/2022"]
[null,null,null,null,null,null,"Modificado por","ADVIVIEYRA",null,"Hora de modificación","07/05/2020 10:37:04"]
[null,null,null,null,null,null,"InfoSitio","ZVRL_MP02",null,"Actualidad de datos","25/01/2022 14:24:31"]
[null,null,null,null,null,null,"Nombre técnico query","ZFI_VRL_MP02_Q008A",null,"Actualidad datos (fecha)","25/01/2022"]
[null,null,null,null,null,null,"Descripción query","Estado de Situacion Financiera Det A",null,"Actualidad datos (fecha)","14:24:31"]
[]
[]
[null,null,"Filter",null,null," "]
[null,null,"Área funcional","",null," "]
[null,null,"Centro de beneficio","",null," "]
[null,null,"Centro de coste","",null," "]
[null,null,"Cuenta de mayor","",null," "]
[null,null,"Ejercicio/Período","",null," "]
[null,null,"Ejercicio","",null," "]
[null,null,"Estruct.","",null," "]
[null,null,"InfoSitio","",null," "]
[null,null,"Período contable","",null," "]
[null,null,"Ratios","",null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]